package com.guigu.eduservice.mapper;

import com.guigu.eduservice.entity.Equipment;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 * 设备表（存储卖家发布的二手机械信息） Mapper 接口
 * </p>
 *
 * @author janecraft
 * @since 2025-09-27
 */
public interface EquipmentMapper extends BaseMapper<Equipment> {

    /**
     * 获取今日新增设备数量
     */
    @Select("SELECT COUNT(*) FROM equipment WHERE DATE(create_time) = CURDATE()")
    int getTodayDeviceCount();
}
